Read Range
AutomatR.GoogleSheets.Activities.ReadRange
The "Read Range" activity in AutomatR is part of the Google Sheets activities package, designed to read the contents of a specified range in a Google spreadsheet and convert it to a DataTable. This activity streamlines the process of extracting structured data from Google Sheets, enhancing the efficiency of automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Specifies the range of cells that you want to read. String variables containing the cell range (e.g., "A1:B5"). |
| Include Headers | When enabled, considers the first row as headers in the mentioned range of cells. Boolean variables indicating whether to include headers. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Read Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Outputs the data extracted from the specified range in a DataTable variable. DataTable variables to store the extracted data. |
How to use:
- Drag and drop the "Read Range" activity onto the workflow.
- Configure the properties by specifying the range of cells to read, whether to include headers, and optional settings like Delay.
- Place the "Read Range" activity within a "Google Sheets App Scope" to ensure proper authentication and access to the Google Sheets service.
- Execute the workflow to retrieve data from the specified range in the Google spreadsheet.
Example: Consider an example where the "Read Range" activity is used to read data from cells A1 to B5 in a Google Sheet named "Expense Sheet" and includes headers:
Read Range:
Range: "A1:B5"
Include Headers: true
Delay: 1
Result: dataTable
In this example, the activity reads data from the specified range, considering the first row as headers, and stores the result in the DataTable variable "dataTable" for further use in the workflow.